Lista referencji diagramu

Name

Code

Parent Table

Child Table

Foreign Key Columns

Parent Role

Child Role

R_45

R_45

ContractService

PerfContractService

Con_ContractServID

 

 

R_148

R_148

Event

PerfResource

EventID

 

 

R_350

R_350

Event

PerfContractService

EventID

 

 

R_365

R_365

UserDefinition

Action

PersonID

 

 

R_592

R_592

Contractor

LEventContractor

ContractorID

 

 

R_595

R_595

Contractor

LContractServOrgUnitContr

ContractorID

 

 

R_596

R_596

ContractData

LContractServContractor

ContractDataID

 

 

R_597

R_597

ContractService

LContractServOrgUnitContr

ContractServID

 

 

R_598

R_598

Contractor

PerfContractService

ContractorID

 

 

R_682

R_682

Unit

Service

UnitID

 

 

R_713

R_713

Contractor

LContractServContractor

ContractorID

 

 

R_716

R_716

ContractData

LContractServOrgUnitContr

ContractDataID

 

 

R_728

R_728

ContractPayments

LPaymentContract

ContractPaymentID

 

 

R_729

R_729

ContractData

LPaymentContract

ContractDataID

 

 

R_737

R_737

LimitType

ContractLimit

LimitTypeID

 

 

R_738

R_738

LimitType

LimitTypeText

LimitTypeID

 

 

R_741

R_741

PerfContractService

LPerfContrServPerfContrServ

ContractServicePerfID

 

 

R_742

R_742

PerfContractService

LPerfContrServPerfContrServ

Per_ContractServicePerfID

 

 

R_747

R_747

Unit

LContractServContractServ

UnitID

 

 

R_752

R_752

ContractService

LContractServiceClass

ContractServID

 

 

R_753

R_753

ContractServiceClass

LContractServiceClass

ContractServiceClassID

 

 

R_754

R_754

ContractServiceClass

ContractServiceClassText

ContractServiceClassID

 

 

R_845

R_845

Contract

LContractContract

Con_ContractID

 

 

R_846

R_846

Contract

LContractContract

ContractID

 

 

R_847

R_847

Contract

ContractData

ContractID

 

 

R_934

R_934

LimitGroup

LimitType

LimitGroupID

 

 

R_935

R_935

LimitGroup

LimitGroupText

LimitGroupID

 

 

R_948

R_948

ContractServiceType

ContractService

ContractServiceTypeID

 

 

R_949

R_949

ContractService

ContractService

Con_ContractServID

 

 

R_950

R_950

ContractServiceKind

ContractServiceKindText

ContractServiceKindID

 

 

R_952

R_952

ContractServiceType

ContractServiceTypeText

ContractServiceTypeID

 

 

R_1113

R_1113

PerfContrServStatus

PerfContrServStatusText

PerfContrServStatusID

 

 

R_1115

R_1115

PerfContrServStatus

PerfContractService

PerfContrServStatusID

 

 

R_1117

R_1117

Contractor

LContractServService

ContractorID

 

 

R_1134

R_1134

PerfResource

LPerfResPerfContrServ

PerfResourceID

 

 

R_1135

R_1135

TreatmentSchema

LPerfResPerfContrServ

TreatmentSchemaID

 

 

R_1136

R_1136

PerfContractService

LPerfResPerfContrServ

ContractServicePerfID

 

 

R_1179

R_1179

PerfContractService

PerfContractService

Per_ContractServicePerfID

 

 

R_1180

R_1180

ContractOrgUnit

LContractServOrgUnitContr

ContractOrgUnitID

 

 

R_1192

R_1192

ContractService

LPerfResPerfContrServ

ContractServID

 

 

R_1329

R_1329

DoseCalcMethod

LPerfResPerfContrServ

DoseCalcMethodID

 

 

R_1330

R_1330

Contractor

Contractor

Con_ContractorID

 

 

R_1462

R_1462

PerfContractService

LPerfContrServStatus

ContractServicePerfID

 

 

R_1463

R_1463

PerfContrServStatus

LPerfContrServStatus

PerfContrServStatusID

 

 

R_1464

R_1464

UserDefinition

LPerfContrServStatus

PersonID

 

 

R_1490

R_1490

PerfContrServStatus

LEventPerfContrServStatus

PerfContrServStatusID

 

 

R_1491

R_1491

Event

LEventPerfContrServStatus

EventID

 

 

R_1492

R_1492

UserDefinition

LEventPerfContrServStatus

PersonID

 

 

R_1617

R_1617

ContractOrgUnit

LContractOrgUnit

ContractOrgUnitID

 

 

R_1810

R_1810

OverLimitAction

ContractLimit

OverLimitActionID

 

 


2